Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

1 Subject

Analytics 1 -Discussion

Analytics 1 -Discussion

Q Explain 3 uses of Pivot Tables for your business or personal use. What are some requirements of the data file in order to create a Pivot Table? What are some tricks you can use in Excel to get the data file in the format you need it?

View Related Questions

Solution Preview

The pivot table is an excellent tool in the Excel that helps one in the data analysis. The main objective of a pivot table is to summarize the data. The pivot table sorts, rearranges and groups the variable based on certain criteria. Pivot table can be used in an organization to find the employees drawing the maximum salaries. The organization can also use the pivot table to identify their best selling products. I think one can use the pivot table to get an idea about their monthly budget by identifying the most bought products. For an example, after summing up the budgets into different categories, one can use the pivot table to represent the categories based on the price. The pivot table not only analyses the data in a better way, but also represent them in a more comprehensible form.